Labels:text | screenshot | font | number | black and white OCR: Cursor Type Description Forward Only The forward-only cursor isn't really a cursor, because you can't scroll bockword through the result set. This is the default cursor you'll receive if you don't specify one on the call to OpenResultset or CreatePreparedStatement. Static The static cursor enables you to move through the result set in both directions. However, the data doesn't change to reflect updates. Use this cursor if you don't expect many users, or if you need to scroll in both directions through a read-only result set, Keyset The keyset-driven cursor is a hybrid of the dynamic and static cursors. You specify a default keyset size, which is fetched from the server. You also specify a rowset size, which tells your application to buffer a certain amount of the result set equal to the rowset size: When you scroll beyond the rowset; the data is fetched from the keyset buffer. Just as the static cursor, the keyset cursor retrieves dato from the cache, not the server. However, if you scroll past the keyset, the cursor becomes dynamic (for a short time) and fetches another keyset of rows from the server, which would show the updates as of the feich. Then the process begins agoin. Dynamic The dynamic cursor is straightforward in concept; you simply open a cursor that updates itself as changes are made to the underlying data. Figure 1: The four RDO cursor types.
(2000).iso/visua/831/lestf101.gif){kind=small}
(2000).iso/visua/831/johnf105.gif){kind=link}
(2000).iso/visua/831/mohsf101.gif){kind=link}